if exists (select name from sysobjects where name like 'Proc_TKKyHan_GetById')
	drop procedure Proc_TKKyHan_GetById
go

create PROC Proc_TKKyHan_GetById (@maLoai int )
as
	select * from TKKyHan
	where @maLoai= TKKyHan.MaLoai
go

Exec Proc_TKKyHan_GetById 1
go


--------------------------------
--------------Xem thong tin ky han thong qua ten -----------------------
if exists (select name from sysobjects where name like 'Proc_TKKyHan_GetByTen')
	drop procedure Proc_TKKyHan_GetByTen
go

create PROC Proc_TKKyHan_GetByTen (@ma nvarchar )
as
	select * from TKKyHan
	where @ma= TKKyHan.Ten
go
